package org.jeecg.modules.engineering.mapper;


import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.engineering.entity.EquipEventNoticeUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;

/**
 * @Description: 事件通知人表
 * @Author: jeecg-boot
 * @Date:   2019-09-28
 * @Version: V1.0
 */
@Repository
public interface EquipEventNoticeUserMapper extends BaseMapper<EquipEventNoticeUser> {

    @Select("SELECT * FROM equip_event_notice_user WHERE del_flag = 0 AND notice_type_id = #{noticeTypeId} AND notice_user_id = #{userId}")
    EquipEventNoticeUser selectByIdAndUser(@Param("noticeTypeId")String noticeTypeId, @Param("userId")String userId);
}
